<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
	<head>
		<title></title>
		<meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.1">
		<meta name="ProgId" content="VisualStudio.HTML">
		<meta name="Originator" content="Microsoft Visual Studio .NET 7.1">
	</head>
	<body>
		<H1><A name="_parameters_(t-sql)"></A>PARAMETERS</H1>
		<P>Contains one row for each parameter of a user-defined function or stored 
			procedure accessible to the current user in the current database. For 
			functions, this view also returns one row with return value information.</P>
		<P>The<B> INFORMATION_SCHEMA.PARAMETERS</B> view is based on the <B>sysobjects</B> and
			<B>syscolumns</B> system tables.</P>
		<P>To retrieve information from these views, specify the fully qualified name of <B>INFORMATION_SCHEMA</B>
			<I>view_name</I>.</P>
		<TABLE id="Table1" cols="3" cellPadding="2" rules="all" width="595" border="1" frame="box">
			<TR vAlign="top">
				<TH class="label" width="36%">
					Column name</TH>
				<TH class="label" width="22%">
					Data type</TH>
				<TH class="label" width="42%">
					Description</TH></TR>
			<TR vAlign="top">
				<TD width="36%"><B>SPECIFIC_CATALOG</B></TD>
				<TD width="22%"><B>nvarchar(128)</B></TD>
				<TD width="42%">Catalog name of the ROUTINE for which this is a parameter.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>SPECIFIC_SCHEMA</B></TD>
				<TD width="22%"><B>nvarchar(128)</B></TD>
				<TD width="42%">Owner name of the ROUTINE for which this is a parameter.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>SPECIFIC_NAME</B></TD>
				<TD width="22%"><B>nvarchar(128)</B></TD>
				<TD width="42%">Name of the ROUTINE for which this is a parameter.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>ORDINAL_POSITION</B></TD>
				<TD width="22%"><B>smallint</B></TD>
				<TD width="42%">Ordinal position of the parameter starting at 1. For the return 
					value of a function, this is a 0.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>PARAMETER_MODE</B></TD>
				<TD width="22%"><B>nvarchar(10)</B></TD>
				<TD width="42%">Returns IN if an input parameter, OUT if an output parameter, and 
					INOUT if an input/output parameter.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>IS_RESULT</B></TD>
				<TD width="22%"><B>nvarchar(10)</B></TD>
				<TD width="42%">Returns YES if indicates result of the routine that is a function. 
					Otherwise, returns NO.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>AS_LOCATOR</B></TD>
				<TD width="22%"><B>nvarchar(10)</B></TD>
				<TD width="42%">Returns YES if declared as locator. Otherwise, returns NO.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>PARAMETER_NAME</B></TD>
				<TD width="22%"><B>nvarchar(128)</B></TD>
				<TD width="42%">Name of the parameter. NULL if this corresponds to the return value 
					of a function.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>DATA_TYPE</B></TD>
				<TD width="22%"><B>nvarchar(128)</B></TD>
				<TD width="42%">System-supplied data type.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>CHARACTER_MAXIMUM_LENGTH</B></TD>
				<TD width="22%"><B>int</B></TD>
				<TD width="42%">Maximum length in characters for binary or character data types. 
					Otherwise, returns NULL.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>CHARACTER_OCTET_LENGTH</B></TD>
				<TD width="22%"><B>int</B></TD>
				<TD width="42%">Maximum length, in bytes, for binary or character data types. 
					Otherwise, returns NULL.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>COLLATION_CATALOG</B></TD>
				<TD width="22%"><B>nvarchar(128)</B></TD>
				<TD width="42%">Catalog name of the collation of the parameter. If not one of the 
					character types, returns NULL.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>COLLATION_SCHEMA</B></TD>
				<TD width="22%"><B>nvarchar(128)</B></TD>
				<TD width="42%">Schema name of the collation of the parameter. If not one of the 
					character types, returns NULL.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>COLLATION_NAME</B></TD>
				<TD width="22%"><B>nvarchar(128)</B></TD>
				<TD width="42%">Name of the collation of the parameter. If not one of the character 
					types, returns NULL.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>CHARACTER_SET_CATALOG</B></TD>
				<TD width="22%"><B>nvarchar(128)</B></TD>
				<TD width="42%">Catalog name of the character set of the parameter. If not one of 
					the character types, returns NULL.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>CHARACTER_SET_SCHEMA</B></TD>
				<TD width="22%"><B>nvarchar(128)</B></TD>
				<TD width="42%">Owner name of the character set of the parameter. If not one of the 
					character types, returns NULL.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>CHARACTER_SET_NAME</B></TD>
				<TD width="22%"><B>nvarchar(128)</B></TD>
				<TD width="42%">Name of the character set of the parameter. If not one of the 
					character types, returns NULL.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>NUMERIC_PRECISION</B></TD>
				<TD width="22%"><B>tinyint</B></TD>
				<TD width="42%">Precision of approximate numeric data, exact numeric data, integer 
					data, or monetary data. Otherwise, returns NULL.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>NUMERIC_PRECISION_RADIX</B></TD>
				<TD width="22%"><B>smallint</B></TD>
				<TD width="42%">Precision radix of approximate numeric data, exact numeric data, 
					integer data, or monetary data. Otherwise, returns NULL.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>NUMERIC_SCALE</B></TD>
				<TD width="22%"><B>tinyint</B></TD>
				<TD width="42%">Scale of approximate numeric data, exact numeric data, integer 
					data, or monetary data. Otherwise, returns NULL.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>DATETIME_PRECISION</B></TD>
				<TD width="22%"><B>smallint</B></TD>
				<TD width="42%">Precision in fractional seconds if the parameter type is <B>datetime</B>
					or <B>smalldatetime</B>. Otherwise, returns NULL.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>INTERVAL_TYPE</B></TD>
				<TD width="22%"><B>nvarchar(30)</B></TD>
				<TD width="42%">NULL. Reserved for future use.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>INTERVAL_PRECISION</B></TD>
				<TD width="22%"><B>smallint</B></TD>
				<TD width="42%">NULL. Reserved for future use.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>USER_DEFINED_TYPE_CATALOG</B></TD>
				<TD width="22%"><B>nvarchar(128)</B></TD>
				<TD width="42%">NULL. Reserved for future use.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>USER_DEFINED_TYPE_SCHEMA</B></TD>
				<TD width="22%"><B>nvarchar(128)</B></TD>
				<TD width="42%">NULL. Reserved for future use.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>USER_DEFINED_TYPE_NAME</B></TD>
				<TD width="22%"><B>nvarchar(128)</B></TD>
				<TD width="42%">NULL. Reserved for future use.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>SCOPE_CATALOG</B></TD>
				<TD width="22%"><B>nvarchar(128)</B></TD>
				<TD width="42%">NULL. Reserved for future use.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>SCOPE_SCHEMA</B></TD>
				<TD width="22%"><B>nvarchar(128)</B></TD>
				<TD width="42%">NULL. Reserved for future use.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="36%"><B>SCOPE_NAME</B></TD>
				<TD width="22%"><B>nvarchar(128)</B></TD>
				<TD width="42%">
				NULL. Reserved for future use.</TR>
		</TABLE>
	</body>
</html>
